| ocean_proximity | longitude | latitude | housing_median_age | total_rooms | total_bedrooms | population | households | median_income | median_house_value | |
|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 259212.311790 | -122.230000 | 37.880000 | 41.000000 | 880.000000 | 129.000000 | 322.000000 | 126.000000 | 8.325200 | 452600.000000 |
| 1 | 259212.311790 | -122.220000 | 37.860000 | 21.000000 | 7099.000000 | 1106.000000 | 2401.000000 | 1138.000000 | 8.301400 | 358500.000000 |
| 2 | 259212.311790 | -122.240000 | 37.850000 | 52.000000 | 1467.000000 | 190.000000 | 496.000000 | 177.000000 | 7.257400 | 352100.000000 |
| 3 | 259212.311790 | -122.250000 | 37.850000 | 52.000000 | 1274.000000 | 235.000000 | 558.000000 | 219.000000 | 5.643100 | 341300.000000 |
| 4 | 259212.311790 | -122.250000 | 37.850000 | 52.000000 | 1627.000000 | 280.000000 | 565.000000 | 259.000000 | 3.846200 | 342200.000000 |
| ocean_proximity | longitude | latitude | housing_median_age | total_rooms | total_bedrooms | population | households | median_income | median_house_value | |
|---|---|---|---|---|---|---|---|---|---|---|
| 20635 | 124805.392001 | -121.090000 | 39.480000 | 25.000000 | 1665.000000 | 374.000000 | 845.000000 | 330.000000 | 1.560300 | 78100.000000 |
| 20636 | 124805.392001 | -121.210000 | 39.490000 | 18.000000 | 697.000000 | 150.000000 | 356.000000 | 114.000000 | 2.556800 | 77100.000000 |
| 20637 | 124805.392001 | -121.220000 | 39.430000 | 17.000000 | 2254.000000 | 485.000000 | 1007.000000 | 433.000000 | 1.700000 | 92300.000000 |
| 20638 | 124805.392001 | -121.320000 | 39.430000 | 18.000000 | 1860.000000 | 409.000000 | 741.000000 | 349.000000 | 1.867200 | 84700.000000 |
| 20639 | 124805.392001 | -121.240000 | 39.370000 | 16.000000 | 2785.000000 | 616.000000 | 1387.000000 | 530.000000 | 2.388600 | 89400.000000 |
No missing values in data
No Infinity values
No Missing Values
No duplicate variables
| N | < (mean-3*std) | > (mean+3*std) | < (1stQ - 1.5 * IQR) | > (3rdQ + 1.5 * IQR) | -inf | +inf | |
|---|---|---|---|---|---|---|---|
| Feature | |||||||
| ocean_proximity | 20640 | 0 | 5 | 0 | 0 | 0 | 0 |
| total_rooms | 20640 | 0 | 569 | 0 | 1287 | 0 | 0 |
| total_bedrooms | 20640 | 0 | 568 | 0 | 1306 | 0 | 0 |
| population | 20640 | 0 | 534 | 0 | 1196 | 0 | 0 |
| households | 20640 | 0 | 577 | 0 | 1220 | 0 | 0 |
| median_income | 20640 | 0 | 393 | 0 | 681 | 0 | 0 |
| median_house_value | 20640 | 0 | 0 | 0 | 1071 | 0 | 0 |
| Variable Name | Datatype | No of Unique | Samples | Mean | Standard Deviation | Min | 25th percentile | Median | 75th percentile | Max | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | households | float64 | 1372 | [126.0, 1138.0, 177.0, 219.0, 259.0] | 483.300604 | 304.119753 | 1.000000 | 280.000000 | 409.000000 | 605.000000 | 1444.898552 |
| 1 | housing_median_age | float64 | 52 | [41.0, 21.0, 52.0, 42.0, 50.0] | 28.639486 | 12.585558 | 1.000000 | 18.000000 | 29.000000 | 37.000000 | 52.000000 |
| 2 | latitude | float64 | 862 | [37.88, 37.86, 37.85, 37.84, 37.83] | 35.631861 | 2.135952 | 32.540000 | 33.930000 | 34.260000 | 37.710000 | 41.950000 |
| 3 | longitude | float64 | 844 | [-122.23, -122.22, -122.24, -122.25, -122.26] | -119.569704 | 2.003532 | -124.350000 | -121.800000 | -118.490000 | -118.010000 | -114.310000 |
| 4 | median_house_value | float64 | 3842 | [452600.0, 358500.0, 352100.0, 341300.0, 342200.0] | 206855.816909 | 115395.615874 | 14999.000000 | 119600.000000 | 179700.000000 | 264725.000000 | 500001.000000 |
| 5 | median_income | float64 | 12588 | [8.3252, 8.3014, 7.2574, 5.6431, 3.8462] | 3.828054 | 1.732575 | 0.499900 | 2.563400 | 3.534800 | 4.743250 | 9.111127 |
| 6 | ocean_proximity | float64 | 5 | [259212.31179039303, 240084.28546409807, 124805.39200122119, 249433.97742663656, 375771.26497790066] | 206854.685917 | 56304.272260 | 124805.392001 | 124805.392001 | 240084.285464 | 240084.285464 | 375771.264978 |
| 7 | population | float64 | 3394 | [322.0, 2401.0, 496.0, 558.0, 565.0] | 1377.032847 | 874.000069 | 3.000000 | 787.000000 | 1166.000000 | 1725.000000 | 4158.041139 |
| 8 | total_bedrooms | float64 | 1479 | [129.0, 1106.0, 190.0, 235.0, 280.0] | 518.336004 | 330.347698 | 1.000000 | 297.000000 | 435.000000 | 643.250000 | 1567.577674 |
| 9 | total_rooms | float64 | 5382 | [880.0, 7099.0, 1467.0, 1274.0, 1627.0] | 2528.653356 | 1633.787389 | 2.000000 | 1447.750000 | 2127.000000 | 3148.000000 | 7788.680616 |
No categorical columns
No categorical variables in data.
| Variable 1 | Variable 2 | Corr Coef | Abs Corr Coef | |
|---|---|---|---|---|
| 0 | median_house_value | median_income | 0.694994 | 0.694994 |
| 1 | median_income | median_house_value | 0.694994 | 0.694994 |
| 2 | ocean_proximity | median_house_value | 0.487953 | 0.487953 |
| 3 | median_house_value | ocean_proximity | 0.487953 | 0.487953 |
| 4 | total_rooms | median_house_value | 0.160465 | 0.160465 |
| 5 | median_house_value | total_rooms | 0.160465 | 0.160465 |
| 6 | latitude | median_house_value | -0.144160 | 0.144160 |
| 7 | median_house_value | latitude | -0.144160 | 0.144160 |
| 8 | median_house_value | housing_median_age | 0.105623 | 0.105623 |
| 9 | housing_median_age | median_house_value | 0.105623 | 0.105623 |
| 10 | households | median_house_value | 0.074558 | 0.074558 |
| 11 | median_house_value | households | 0.074558 | 0.074558 |
| 12 | median_house_value | total_bedrooms | 0.056718 | 0.056718 |
| 13 | total_bedrooms | median_house_value | 0.056718 | 0.056718 |
| 14 | median_house_value | longitude | -0.045967 | 0.045967 |
| 15 | longitude | median_house_value | -0.045967 | 0.045967 |
| 16 | median_house_value | population | -0.030748 | 0.030748 |
| 17 | population | median_house_value | -0.030748 | 0.030748 |